--0016e6db2ae76890b804804719ba
Content-Type: text/plain; charset=ISO-8859-1
yeah that's what I means to do.
How do I use 8.4 pg_restore? the DB server I am trying to restore is using
8.3. Do you mean do pg_restore on the same machine that I did pg_dump?? I am
thinking of doing that too, but I am not sure how to do the command.
Is this correct? pg_restore -h (my target machine IP) -U postgres -d (target
db) mydb.dump
Steven
On Tue, Feb 23, 2010 at 10:31 PM, Richard Huxton <dev [at] archonet.com> wrote:
> On 23/02/10 09:17, Net Tree Inc. wrote:
>
>> Why am I keep getting error with version issues.... I am trying to restore
>> a
>> backup file from a 8.4 postgresql server to a 8.3 postgresql server.
>>
>
> Well, an 8.4 dump isn't always going to be compatible with an 8.3 server,
> is it? If there weren't differences, the version number wouldn't have
> changed.
>
>
> [postgres [at] localhost ~]$ pg_restore -C -d postgres -i isamdb.backup
>> pg_restore.bin: [archiver] unsupported version (1.11) in file header
>>
>
> Try using the 8.4 pg_restore (but keep the "-i" to tell it to ignore the
> version checks). You may still see errors, but there is a good chance it
> will work.
>
> You're also restoring into the "postgres" database here - is that what you
> meant to do?
>
> --
> Richard Huxton
> Archonet Ltd
>
--
---------------------------------------
Steven Huang
--0016e6db2ae76890b804804719ba
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
yeah that's what I means to do. <br><br>How do I use 8.4 pg_restore? th=
e DB server I am trying to restore is using 8.3. Do you mean do pg_restore =
on the same machine that I did pg_dump?? I am thinking of doing that too, b=
ut I am not sure how to do the command. <br>
<br>Is this correct? pg_restore -h (my target machine IP) -U postgres -d (t=
arget db) mydb.dump<br><br>Steven<br><br><div class=3D"gmail_quote">On Tue,=
Feb 23, 2010 at 10:31 PM, Richard Huxton <span dir=3D"ltr"><<a href=3D"=
mailto:dev [at] archonet.com">dev [at] archonet.com</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class=3D"im"=
>On 23/02/10 09:17, Net Tree Inc. wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Why am I keep getting error with version issues.... I am trying to restore =
a<br>
backup file from a 8.4 postgresql server to a 8.3 postgresql server.<br>
</blockquote>
<br></div>
Well, an 8.4 dump isn't always going to be compatible with an 8.3 serve=
r, is it? If there weren't differences, the version number wouldn't=
have changed.<div class=3D"im"><br>
<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
[postgres [at] localhost ~]$ pg_restore -C -d postgres -i isamdb.backup<br>
pg_restore.bin: [archiver] unsupported version (1.11) in file header<br>
</blockquote>
<br></div>
Try using the 8.4 pg_restore (but keep the "-i" to tell it to ign=
ore the version checks). You may still see errors, but there is a good chan=
ce it will work.<br>
<br>
You're also restoring into the "postgres" database here - is =
that what you meant to do?<br><font color=3D"#888888">
<br>
-- <br>
=A0Richard Huxton<br>
=A0Archonet Ltd<br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>----------------=
-----------------------<br>Steven Huang<br>
--0016e6db2ae76890b804804719ba--
